Copyright: Visual Help Copyright® 1993 Firas Bushnaq


CONTENTS
Import Spec Converter

This routine lets you turn an Access Import Specification into a series of Access Basic or Visual Basic code statements. The generated code can be used to read a flat ascii text file, break the records down into individual fields, and then write the record into an Access Table.

You might want to do this, for instance, if you have complex selection criteria, or if you want to create calculated fields on the fly as you import the data. Using the generated code as a starting point you can create a very flexible import routine.

Just fill out the fields on the "Import Spec to Basic Code Conversion" form and press the Generate button.

Database Path

Import Spec Name

Table Name

Import File Name

Record Length

Output File Name

About Import Spec Converter


DBPATH
Database Path

Enter the full DOS path to the database which contains the Import Spec you wish to convert.


IMPSPECNAME
Import Spec Name

Enter the name of the Import Spec which you wish to convert.


Table Name

Enter the name of the table into which your records will be imported.


IMPFILENAME
Import File Name

Enter the full DOS path to the flat file from which you will be importing data. You can change this later in the generated code if necessary.


RECLENGTH
Record Length

Enter the length of one record in the flat file which you will be importing. The size is in bytes. Be sure to include 2 bytes to account for the carraige return/linefeed at the end of each record. If the record includes only a carriage return (if it were created on a Unix system, for example) then add only 1 character.


OUTFILENAME
Output File Name

Enter the name of the DOS .txt or .bas file which will receive the generated Basic source code.


ABOUT
About Import Spec Converter

This utility is free. It was written by:

Jim Ferguson
5016-4 Hunt Club Rd.
Wilmington, NC 28403

CIS ID: 71477,2345